IF EXISTS ( SELECT  *
            FROM    dbo.sysobjects
            WHERE   id = OBJECT_ID(N'CGO_Payment')
                    AND OBJECTPROPERTY(id, N'IsTable') = 1 ) 
  BEGIN
    DROP TABLE dbo.CGO_Payment
  END


CREATE TABLE [dbo].[CGO_Payment]
  (
    [PaymentID] [int] NOT NULL IDENTITY(1, 1) ,
    [PortalID] [int] NOT NULL ,
    [UserID] [int] NOT NULL,
    [Amount] [money] NOT NULL,
    [StatusID] [int] NOT NULL,
    [EnrollmentID] [int] NULL,
    [CreatedDate] [datetime] NOT NULL,
    [LastUpdateDate] [datetime] NOT NULL
  )
ON
  [PRIMARY]
GO
ALTER TABLE [dbo].[CGO_Payment] ADD CONSTRAINT [PK_CGO_Payment] PRIMARY KEY CLUSTERED  ([PaymentID]) ON [PRIMARY]
GO